package com.mhc.suzuki.dal.query;


import com.subaru.common.query.BaseCriteria;
import com.subaru.common.query.BaseQuery;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

public class PaymentRequestQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public PaymentRequestQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table pcl_payment_request
     */
         protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andPaymentRequestIdIsNull() {
            addCriterion("payment_request_id is null");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdIsNotNull() {
            addCriterion("payment_request_id is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdEqualTo(Long value) {
            addCriterion("payment_request_id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdNotEqualTo(Long value) {
            addCriterion("payment_request_id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria anPaymentRequestIdGreaterThan(Long value) {
            addCriterion("payment_request_id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdGreaterThanOrEqualTo(Long value) {
            addCriterion("payment_request_id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdLessThan(Long value) {
            addCriterion("payment_request_id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdLessThanOrEqualTo(Long value) {
            addCriterion("payment_request_id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdIn(List<Long> values) {
            addCriterion("payment_request_id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdNotIn(List<Long> values) {
            addCriterion("payment_request_id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdBetween(Long value1, Long value2) {
            addCriterion("payment_request_id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andPaymentRequestIdNotBetween(Long value1, Long value2) {
            addCriterion("payment_request_id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(LocalDate value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(LocalDate value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(LocalDate value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(LocalDate value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<LocalDate> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<LocalDate> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(LocalDate value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(LocalDate value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(LocalDate value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(LocalDate value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(LocalDate value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<LocalDate> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<LocalDate> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(LocalDate value1, LocalDate value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNull() {
            addCriterion("order_no is null");
            return (Criteria) this;
        }

        public Criteria andOrderNoIsNotNull() {
            addCriterion("order_no is not null");
            return (Criteria) this;
        }

        public Criteria andOrderNoEqualTo(String value) {
            addCriterion("order_no =", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotEqualTo(String value) {
            addCriterion("order_no <>", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThan(String value) {
            addCriterion("order_no >", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("order_no >=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThan(String value) {
            addCriterion("order_no <", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLessThanOrEqualTo(String value) {
            addCriterion("order_no <=", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoLike(String value) {
            addCriterion("order_no like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotLike(String value) {
            addCriterion("order_no not like", value, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoIn(List<String> values) {
            addCriterion("order_no in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotIn(List<String> values) {
            addCriterion("order_no not in", values, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoBetween(String value1, String value2) {
            addCriterion("order_no between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andOrderNoNotBetween(String value1, String value2) {
            addCriterion("order_no not between", value1, value2, "orderNo");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNull() {
            addCriterion("customer_id is null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIsNotNull() {
            addCriterion("customer_id is not null");
            return (Criteria) this;
        }

        public Criteria andCustomerIdEqualTo(Long value) {
            addCriterion("customer_id =", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotEqualTo(Long value) {
            addCriterion("customer_id <>", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThan(Long value) {
            addCriterion("customer_id >", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("customer_id >=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThan(Long value) {
            addCriterion("customer_id <", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLessThanOrEqualTo(Long value) {
            addCriterion("customer_id <=", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdLike(Long value) {
            addCriterion("customer_id like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotLike(Long value) {
            addCriterion("customer_id not like", value, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdIn(List<Long> values) {
            addCriterion("customer_id in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotIn(List<Long> values) {
            addCriterion("customer_id not in", values, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdBetween(Long value1, Long value2) {
            addCriterion("customer_id between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andCustomerIdNotBetween(Long value1, Long value2) {
            addCriterion("customer_id not between", value1, value2, "customerId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdIsNull() {
            addCriterion("loan_info_id is null");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdIsNotNull() {
            addCriterion("loan_info_id is not null");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdEqualTo(Long value) {
            addCriterion("loan_info_id =", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotEqualTo(Long value) {
            addCriterion("loan_info_id <>", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdGreaterThan(Long value) {
            addCriterion("loan_info_id >", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdGreaterThanOrEqualTo(Long value) {
            addCriterion("loan_info_id >=", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdLessThan(Long value) {
            addCriterion("loan_info_id <", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdLessThanOrEqualTo(Long value) {
            addCriterion("loan_info_id <=", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdLike(Long value) {
            addCriterion("loan_info_id like", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotLike(Long value) {
            addCriterion("loan_info_id not like", value, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdIn(List<Long> values) {
            addCriterion("loan_info_id in", values, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotIn(List<Long> values) {
            addCriterion("loan_info_id not in", values, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdBetween(Long value1, Long value2) {
            addCriterion("loan_info_id between", value1, value2, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andLoanInfoIdNotBetween(Long value1, Long value2) {
            addCriterion("loan_info_id not between", value1, value2, "loanInfoId");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameIsNull() {
            addCriterion("payee_account_name is null");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameIsNotNull() {
            addCriterion("payee_account_name is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameEqualTo(String value) {
            addCriterion("payee_account_name =", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameNotEqualTo(String value) {
            addCriterion("payee_account_name <>", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameGreaterThan(String value) {
            addCriterion("payee_account_name >", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameGreaterThanOrEqualTo(String value) {
            addCriterion("payee_account_name >=", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameLessThan(String value) {
            addCriterion("payee_account_name <", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameLessThanOrEqualTo(String value) {
            addCriterion("payee_account_name <=", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameLike(String value) {
            addCriterion("payee_account_name like", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameNotLike(String value) {
            addCriterion("payee_account_name not like", value, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameIn(List<String> values) {
            addCriterion("payee_account_name in", values, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameNotIn(List<String> values) {
            addCriterion("payee_account_name not in", values, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameBetween(String value1, String value2) {
            addCriterion("payee_account_name between", value1, value2, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeAccountNameNotBetween(String value1, String value2) {
            addCriterion("payee_account_name not between", value1, value2, "payeeAccountName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameIsNull() {
            addCriterion("payee_bank_name is null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameIsNotNull() {
            addCriterion("payee_bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameEqualTo(String value) {
            addCriterion("payee_bank_name =", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotEqualTo(String value) {
            addCriterion("payee_bank_name <>", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameGreaterThan(String value) {
            addCriterion("payee_bank_name >", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("payee_bank_name >=", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameLessThan(String value) {
            addCriterion("payee_bank_name <", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameLessThanOrEqualTo(String value) {
            addCriterion("payee_bank_name <=", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameLike(String value) {
            addCriterion("payee_bank_name like", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotLike(String value) {
            addCriterion("payee_bank_name not like", value, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameIn(List<String> values) {
            addCriterion("payee_bank_name in", values, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotIn(List<String> values) {
            addCriterion("payee_bank_name not in", values, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameBetween(String value1, String value2) {
            addCriterion("payee_bank_name between", value1, value2, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankNameNotBetween(String value1, String value2) {
            addCriterion("payee_bank_name not between", value1, value2, "payeeBankName");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardIsNull() {
            addCriterion("payee_bank_card is null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardIsNotNull() {
            addCriterion("payee_bank_card is not null");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardEqualTo(String value) {
            addCriterion("payee_bank_card =", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotEqualTo(String value) {
            addCriterion("payee_bank_card <>", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardGreaterThan(String value) {
            addCriterion("payee_bank_card >", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardGreaterThanOrEqualTo(String value) {
            addCriterion("payee_bank_card >=", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardLessThan(String value) {
            addCriterion("payee_bank_card <", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardLessThanOrEqualTo(String value) {
            addCriterion("payee_bank_card <=", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardLike(String value) {
            addCriterion("payee_bank_card like", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotLike(String value) {
            addCriterion("payee_bank_card not like", value, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardIn(List<String> values) {
            addCriterion("payee_bank_card in", values, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotIn(List<String> values) {
            addCriterion("payee_bank_card not in", values, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardBetween(String value1, String value2) {
            addCriterion("payee_bank_card between", value1, value2, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPayeeBankCardNotBetween(String value1, String value2) {
            addCriterion("payee_bank_card not between", value1, value2, "payeeBankCard");
            return (Criteria) this;
        }

        public Criteria andPaymentWayIsNull() {
            addCriterion("payment_way is null");
            return (Criteria) this;
        }

        public Criteria andPaymentWayIsNotNull() {
            addCriterion("payment_way is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentWayEqualTo(Integer value) {
            addCriterion("payment_way =", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotEqualTo(Integer value) {
            addCriterion("payment_way <>", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayGreaterThan(Integer value) {
            addCriterion("payment_way >", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayGreaterThanOrEqualTo(Integer value) {
            addCriterion("payment_way >=", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayLessThan(Integer value) {
            addCriterion("payment_way <", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayLessThanOrEqualTo(Integer value) {
            addCriterion("payment_way <=", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayLike(Integer value) {
            addCriterion("payment_way like", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotLike(Integer value) {
            addCriterion("payment_way not like", value, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayIn(List<Integer> values) {
            addCriterion("payment_way in", values, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotIn(List<Integer> values) {
            addCriterion("payment_way not in", values, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayBetween(Integer value1, Integer value2) {
            addCriterion("payment_way between", value1, value2, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andPaymentWayNotBetween(Integer value1, Integer value2) {
            addCriterion("payment_way not between", value1, value2, "paymentWay");
            return (Criteria) this;
        }

        public Criteria andLoanUseageIsNull() {
            addCriterion("loan_useage is null");
            return (Criteria) this;
        }

        public Criteria andLoanUseageIsNotNull() {
            addCriterion("loan_useage is not null");
            return (Criteria) this;
        }

        public Criteria andLoanUseageEqualTo(String value) {
            addCriterion("loan_useage =", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageNotEqualTo(String value) {
            addCriterion("loan_useage <>", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageGreaterThan(String value) {
            addCriterion("loan_useage >", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageGreaterThanOrEqualTo(String value) {
            addCriterion("loan_useage >=", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageLessThan(String value) {
            addCriterion("loan_useage <", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageLessThanOrEqualTo(String value) {
            addCriterion("loan_useage <=", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageLike(String value) {
            addCriterion("loan_useage like", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageNotLike(String value) {
            addCriterion("loan_useage not like", value, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageIn(List<String> values) {
            addCriterion("loan_useage in", values, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageNotIn(List<String> values) {
            addCriterion("loan_useage not in", values, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageBetween(String value1, String value2) {
            addCriterion("loan_useage between", value1, value2, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoanUseageNotBetween(String value1, String value2) {
            addCriterion("loan_useage not between", value1, value2, "loanUseage");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountIsNull() {
            addCriterion("loaning_amount is null");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountIsNotNull() {
            addCriterion("loaning_amount is not null");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountEqualTo(java.math.BigDecimal value) {
            addCriterion("loaning_amount =", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountNotEqualTo(java.math.BigDecimal value) {
            addCriterion("loaning_amount <>", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountGreaterThan(java.math.BigDecimal value) {
            addCriterion("loaning_amount >", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountGreaterThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("loaning_amount >=", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountLessThan(java.math.BigDecimal value) {
            addCriterion("loaning_amount <", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountLessThanOrEqualTo(java.math.BigDecimal value) {
            addCriterion("loaning_amount <=", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountLike(java.math.BigDecimal value) {
            addCriterion("loaning_amount like", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountNotLike(java.math.BigDecimal value) {
            addCriterion("loaning_amount not like", value, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountIn(List<java.math.BigDecimal> values) {
            addCriterion("loaning_amount in", values, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountNotIn(List<java.math.BigDecimal> values) {
            addCriterion("loaning_amount not in", values, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("loaning_amount between", value1, value2, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningAmountNotBetween(java.math.BigDecimal value1, java.math.BigDecimal value2) {
            addCriterion("loaning_amount not between", value1, value2, "loaningAmount");
            return (Criteria) this;
        }

        public Criteria andLoaningDateIsNull() {
            addCriterion("loaning_date is null");
            return (Criteria) this;
        }

        public Criteria andLoaningDateIsNotNull() {
            addCriterion("loaning_date is not null");
            return (Criteria) this;
        }

        public Criteria andLoaningDateEqualTo(LocalDateTime value) {
            addCriterion("loaning_date =", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateNotEqualTo(LocalDateTime value) {
            addCriterion("loaning_date <>", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateGreaterThan(LocalDateTime value) {
            addCriterion("loaning_date >", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("loaning_date >=", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateLessThan(LocalDateTime value) {
            addCriterion("loaning_date <", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("loaning_date <=", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateLike(LocalDateTime value) {
            addCriterion("loaning_date like", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateNotLike(LocalDateTime value) {
            addCriterion("loaning_date not like", value, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateIn(List<LocalDateTime> values) {
            addCriterion("loaning_date in", values, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateNotIn(List<LocalDateTime> values) {
            addCriterion("loaning_date not in", values, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("loaning_date between", value1, value2, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andLoaningDateNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("loaning_date not between", value1, value2, "loaningDate");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(Long value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(Long value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(Long value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(Long value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(Long value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(Long value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<Long> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<Long> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(Long value1, Long value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNull() {
            addCriterion("staff_name is null");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNotNull() {
            addCriterion("staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNameEqualTo(String value) {
            addCriterion("staff_name =", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotEqualTo(String value) {
            addCriterion("staff_name <>", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThan(String value) {
            addCriterion("staff_name >", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("staff_name >=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThan(String value) {
            addCriterion("staff_name <", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("staff_name <=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLike(String value) {
            addCriterion("staff_name like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotLike(String value) {
            addCriterion("staff_name not like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameIn(List<String> values) {
            addCriterion("staff_name in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotIn(List<String> values) {
            addCriterion("staff_name not in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameBetween(String value1, String value2) {
            addCriterion("staff_name between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("staff_name not between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdIsNull() {
            addCriterion("handle_staff_id is null");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdIsNotNull() {
            addCriterion("handle_staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdEqualTo(Long value) {
            addCriterion("handle_staff_id =", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotEqualTo(Long value) {
            addCriterion("handle_staff_id <>", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdGreaterThan(Long value) {
            addCriterion("handle_staff_id >", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdGreaterThanOrEqualTo(Long value) {
            addCriterion("handle_staff_id >=", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdLessThan(Long value) {
            addCriterion("handle_staff_id <", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdLessThanOrEqualTo(Long value) {
            addCriterion("handle_staff_id <=", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdLike(Long value) {
            addCriterion("handle_staff_id like", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotLike(Long value) {
            addCriterion("handle_staff_id not like", value, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdIn(List<Long> values) {
            addCriterion("handle_staff_id in", values, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotIn(List<Long> values) {
            addCriterion("handle_staff_id not in", values, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdBetween(Long value1, Long value2) {
            addCriterion("handle_staff_id between", value1, value2, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andHandleStaffIdNotBetween(Long value1, Long value2) {
            addCriterion("handle_staff_id not between", value1, value2, "handleStaffId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNull() {
            addCriterion("dept_id is null");
            return (Criteria) this;
        }

        public Criteria andDeptIdIsNotNull() {
            addCriterion("dept_id is not null");
            return (Criteria) this;
        }

        public Criteria andDeptIdEqualTo(Long value) {
            addCriterion("dept_id =", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotEqualTo(Long value) {
            addCriterion("dept_id <>", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThan(Long value) {
            addCriterion("dept_id >", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdGreaterThanOrEqualTo(Long value) {
            addCriterion("dept_id >=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThan(Long value) {
            addCriterion("dept_id <", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLessThanOrEqualTo(Long value) {
            addCriterion("dept_id <=", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdLike(Long value) {
            addCriterion("dept_id like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotLike(Long value) {
            addCriterion("dept_id not like", value, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdIn(List<Long> values) {
            addCriterion("dept_id in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotIn(List<Long> values) {
            addCriterion("dept_id not in", values, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdBetween(Long value1, Long value2) {
            addCriterion("dept_id between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptIdNotBetween(Long value1, Long value2) {
            addCriterion("dept_id not between", value1, value2, "deptId");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNull() {
            addCriterion("dept_name is null");
            return (Criteria) this;
        }

        public Criteria andDeptNameIsNotNull() {
            addCriterion("dept_name is not null");
            return (Criteria) this;
        }

        public Criteria andDeptNameEqualTo(String value) {
            addCriterion("dept_name =", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotEqualTo(String value) {
            addCriterion("dept_name <>", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThan(String value) {
            addCriterion("dept_name >", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameGreaterThanOrEqualTo(String value) {
            addCriterion("dept_name >=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThan(String value) {
            addCriterion("dept_name <", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLessThanOrEqualTo(String value) {
            addCriterion("dept_name <=", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameLike(String value) {
            addCriterion("dept_name like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotLike(String value) {
            addCriterion("dept_name not like", value, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameIn(List<String> values) {
            addCriterion("dept_name in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotIn(List<String> values) {
            addCriterion("dept_name not in", values, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameBetween(String value1, String value2) {
            addCriterion("dept_name between", value1, value2, "deptName");
            return (Criteria) this;
        }

        public Criteria andDeptNameNotBetween(String value1, String value2) {
            addCriterion("dept_name not between", value1, value2, "deptName");
            return (Criteria) this;
        }

        public Criteria andApplyStatusIsNull() {
            addCriterion("apply_status is null");
            return (Criteria) this;
        }

        public Criteria andApplyStatusIsNotNull() {
            addCriterion("apply_status is not null");
            return (Criteria) this;
        }

        public Criteria andApplyStatusEqualTo(Integer value) {
            addCriterion("apply_status =", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusNotEqualTo(Integer value) {
            addCriterion("apply_status <>", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusGreaterThan(Integer value) {
            addCriterion("apply_status >", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("apply_status >=", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusLessThan(Integer value) {
            addCriterion("apply_status <", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusLessThanOrEqualTo(Integer value) {
            addCriterion("apply_status <=", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusLike(Integer value) {
            addCriterion("apply_status like", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusNotLike(Integer value) {
            addCriterion("apply_status not like", value, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusIn(List<Integer> values) {
            addCriterion("apply_status in", values, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusNotIn(List<Integer> values) {
            addCriterion("apply_status not in", values, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusBetween(Integer value1, Integer value2) {
            addCriterion("apply_status between", value1, value2, "applyStatus");
            return (Criteria) this;
        }

        public Criteria andApplyStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("apply_status not between", value1, value2, "applyStatus");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table pcl_payment_request
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}